<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="UTF-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
	<title>DBeaver | ElasticSearch 7.7 权威指南中文版</title>
	<meta name="keywords" content="ElasticSearch 权威指南中文版, elasticsearch 7, es7, 实时数据分析，实时数据检索" />
    <meta name="description" content="ElasticSearch 权威指南中文版, elasticsearch 7, es7, 实时数据分析，实时数据检索" />
    <!-- Give IE8 a fighting chance -->
    <!--[if lt IE 9]>
    <script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
    <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
    <![endif]-->
	<link rel="stylesheet" type="text/css" href="../static/styles.css" />
	<script>
	var _link = 'sql-client-apps-dbeaver.html';
    </script>
</head>
<body>
<div class="main-container">
    <section id="content">
        <div class="content-wrapper">
            <section id="guide" lang="zh_cn">
                <div class="container">
                    <div class="row">
                        <div class="col-xs-12 col-sm-8 col-md-8 guide-section">
                            <div style="color:gray; word-break: break-all; font-size:12px;">原英文版地址: <a href="https://www.elastic.co/guide/en/elasticsearch/reference/7.7/sql-client-apps-dbeaver.html" rel="nofollow" target="_blank">https://www.elastic.co/guide/en/elasticsearch/reference/7.7/sql-client-apps-dbeaver.html</a>, 原文档版权归 www.elastic.co 所有<br/>本地英文版地址: <a href="../en/sql-client-apps-dbeaver.html" rel="nofollow" target="_blank">../en/sql-client-apps-dbeaver.html</a></div>
                        <!-- start body -->
                  <div class="page_header">
<strong>重要</strong>: 此版本不会发布额外的bug修复或文档更新。最新信息请参考 <a href="https://www.elastic.co/guide/en/elasticsearch/reference/current/index.html" rel="nofollow">当前版本文档</a>。
</div>
<div id="content">
<div class="breadcrumbs">
<span class="breadcrumb-link"><a href="index.html">Elasticsearch Guide [7.7]</a></span>
»
<span class="breadcrumb-link"><a href="xpack-sql.html">SQL access</a></span>
»
<span class="breadcrumb-link"><a href="sql-client-apps.html">SQL Client Applications</a></span>
»
<span class="breadcrumb-node">DBeaver</span>
</div>
<div class="navheader">
<span class="prev">
<a href="sql-client-apps.html">« SQL Client Applications</a>
</span>
<span class="next">
<a href="sql-client-apps-dbvis.html">DbVisualizer »</a>
</span>
</div>
<div class="section xpack">
<div class="titlepage"><div><div>
<h2 class="title">
<a id="sql-client-apps-dbeaver"></a>DBeaver<a class="edit_me edit_me_private" rel="nofollow" title="Editing on GitHub is available to Elastic" href="https://github.com/elastic/elasticsearch/edit/7.7/docs/reference/sql/endpoints/client-apps/dbeaver.asciidoc">edit</a><a class="xpack_tag" href="https://www.elastic.co/subscriptions"></a>
</h2>
</div></div></div>
<p>You can use the Elasticsearch JDBC driver to access Elasticsearch data from DBeaver.</p>
<div class="important admon">
<div class="icon"></div>
<div class="admon_content">
<p>Elastic does not endorse, promote or provide support for this application; for native Elasticsearch integration in this product, please reach out to its vendor.</p>
</div>
</div>
<div class="section">
<div class="titlepage"><div><div>
<h3 class="title">
<a id="_prerequisites"></a>Prerequisites<a class="edit_me edit_me_private" rel="nofollow" title="Editing on GitHub is available to Elastic" href="https://github.com/elastic/elasticsearch/edit/7.7/docs/reference/sql/endpoints/client-apps/dbeaver.asciidoc">edit</a>
</h3>
</div></div></div>
<div class="ulist itemizedlist">
<ul class="itemizedlist">
<li class="listitem">
<a href="https://dbeaver.io/" class="ulink" target="_top">DBeaver</a> version 6.0.0 or higher
</li>
<li class="listitem">
Elasticsearch SQL <a class="xref" href="sql-jdbc.html" title="SQL JDBC">JDBC driver</a>
</li>
</ul>
</div>
</div>

<div class="section">
<div class="titlepage"><div><div>
<h3 class="title">
<a id="_new_connection"></a>New Connection<a class="edit_me edit_me_private" rel="nofollow" title="Editing on GitHub is available to Elastic" href="https://github.com/elastic/elasticsearch/edit/7.7/docs/reference/sql/endpoints/client-apps/dbeaver.asciidoc">edit</a>
</h3>
</div></div></div>
<p>Create a new connection either through the menu <span class="strong strong"><strong>File</strong></span> &gt; <span class="strong strong"><strong>New</strong></span> &gt; <span class="strong strong"><strong>Database Connection</strong></span> menu or directly through the <span class="strong strong"><strong>Database Connection</strong></span> panel.</p>
<p><span class="image"><img src="../static/images/sql/client-apps/dbeaver-1-new-conn.png" alt="dbeaver 1 new conn"></span></p>
</div>

<div class="section">
<div class="titlepage"><div><div>
<h3 class="title">
<a id="_select_elasticsearch_type"></a>Select Elasticsearch type<a class="edit_me edit_me_private" rel="nofollow" title="Editing on GitHub is available to Elastic" href="https://github.com/elastic/elasticsearch/edit/7.7/docs/reference/sql/endpoints/client-apps/dbeaver.asciidoc">edit</a>
</h3>
</div></div></div>
<p>Select the Elasticsearch type from the available connection types:</p>
<p><span class="image"><img src="../static/images/sql/client-apps/dbeaver-2-conn-es.png" alt="dbeaver 2 conn es"></span></p>
</div>

<div class="section">
<div class="titlepage"><div><div>
<h3 class="title">
<a id="_specify_the_elasticsearch_cluster_information"></a>Specify the Elasticsearch cluster information<a class="edit_me edit_me_private" rel="nofollow" title="Editing on GitHub is available to Elastic" href="https://github.com/elastic/elasticsearch/edit/7.7/docs/reference/sql/endpoints/client-apps/dbeaver.asciidoc">edit</a>
</h3>
</div></div></div>
<p>Configure the Elasticsearch SQL connection appropriately:</p>
<p><span class="image"><img src="../static/images/sql/client-apps/dbeaver-3-conn-props.png" alt="dbeaver 3 conn props"></span></p>
</div>

<div class="section">
<div class="titlepage"><div><div>
<h3 class="title">
<a id="_verify_the_driver_version"></a>Verify the driver version<a class="edit_me edit_me_private" rel="nofollow" title="Editing on GitHub is available to Elastic" href="https://github.com/elastic/elasticsearch/edit/7.7/docs/reference/sql/endpoints/client-apps/dbeaver.asciidoc">edit</a>
</h3>
</div></div></div>
<p>Make sure the correct JDBC driver version is used by using the <span class="strong strong"><strong>Edit Driver Settings</strong></span> button:</p>
<p><span class="image"><img src="../static/images/sql/client-apps/dbeaver-4-driver-ver.png" alt="dbeaver 4 driver ver"></span></p>
<p>DBeaver is aware of the Elasticsearch JDBC maven repository so simply <span class="strong strong"><strong>Download/Update</strong></span> the artifact or add a new one. As an alternative one can add a local file instead if the Elasticsearch Maven repository is not an option.</p>
<p>When changing the driver, make sure to click on the <span class="strong strong"><strong>Find Class</strong></span> button at the bottom - the Driver class should be picked out automatically however this provides a sanity check that the driver jar is properly found and it is not corrupt.</p>
</div>

<div class="section">
<div class="titlepage"><div><div>
<h3 class="title">
<a id="_test_connectivity"></a>Test connectivity<a class="edit_me edit_me_private" rel="nofollow" title="Editing on GitHub is available to Elastic" href="https://github.com/elastic/elasticsearch/edit/7.7/docs/reference/sql/endpoints/client-apps/dbeaver.asciidoc">edit</a>
</h3>
</div></div></div>
<p>Once the driver version and the settings are in place, use <span class="strong strong"><strong>Test Connection</strong></span> to check that everything works. If things are okay, one should get a confirmation window with the version of the driver and that of Elasticsearch SQL:</p>
<p><span class="image"><img src="../static/images/sql/client-apps/dbeaver-5-test-conn.png" alt="dbeaver 5 test conn"></span></p>
<p>Click <span class="strong strong"><strong>Finish</strong></span> and the new Elasticsearch connection appears in the <span class="strong strong"><strong>Database Connection</strong></span> panel.</p>
<p>DBeaver is now configured to talk to Elasticsearch.</p>
</div>

<div class="section">
<div class="titlepage"><div><div>
<h3 class="title">
<a id="_connect_to_elasticsearch"></a>Connect to Elasticsearch<a class="edit_me edit_me_private" rel="nofollow" title="Editing on GitHub is available to Elastic" href="https://github.com/elastic/elasticsearch/edit/7.7/docs/reference/sql/endpoints/client-apps/dbeaver.asciidoc">edit</a>
</h3>
</div></div></div>
<p>Simply click on the Elasticsearch connection and start querying and exploring Elasticsearch:</p>
<p><span class="image"><img src="../static/images/sql/client-apps/dbeaver-6-data.png" alt="dbeaver 6 data"></span></p>
</div>

</div>
<div class="navfooter">
<span class="prev">
<a href="sql-client-apps.html">« SQL Client Applications</a>
</span>
<span class="next">
<a href="sql-client-apps-dbvis.html">DbVisualizer »</a>
</span>
</div>
</div>

                  <!-- end body -->
                        </div>
                        <div class="col-xs-12 col-sm-4 col-md-4" id="right_col">
                        
                        </div>
                    </div>
                </div>
            </section>
        </div>
    </section>
</div>
<script src="../static/cn.js"></script>
</body>
</html>